package com.example.demo.dao;

import com.example.demo.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ArticleMapper {


    @Select("select userinfo.id as user_id,userinfo.username,articleinfo.id as article_id,articleinfo.title,articleinfo.content from userinfo inner join articleinfo on userinfo.username=articleinfo.username")
    List<ArticleInfo> geAll();
}
